package com.example.demo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo.bean.Cyjl;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CyMapper extends BaseMapper<Cyjl> {

    @Select("SELECT name FROM cyjl WHERE name like #{ch}")
    List<String> selectByTop(String ch);

    @Select("SELECT name FROM cyjl LIMIT #{rand},1")
    String selectRandOne(Integer rand);

}
